home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
AOL File Library: 2,801 to 2,900
/
aol-file-protocol-4400-2801-to-2900.zip
/
AOLDLs
/
Database (AppleWorks)
/
My Macros and Chore Keeper (SHK)
/
CHOREKEEPER.shk
/
MY.MACROS
(
.txt
)
next >
Wrap
AppleWorks Document
|
1993-01-07
|
7KB
|
104 lines
O<====<====<====<====<====<====<====<===<=====<====<====<====<====<====<====<===
O<====<====<====<====<====<====<====<===<=====<====<====<====<====<====<====<===
rtn : oa-P >5< rtn : find : rtn>Y5< rtn : $0="XXXX" :
CUSTOM MACROS
John F. King
5770 Winfield Ct.
Boise, Idaho 83703
REQUIRES APPLEWORKS VERSION 3.0 AND ULTRA MACROS 3.1
DMost of the macros included in this file are ones I have never seen O
Melsewhere, and I use frequently. Some, like ba-c, are common ones I include O
Mon all macro files. Please try these out and let me know if they don't work P
Nor if you have suggestions, improvements, or additions. I would like to know <
if you enjoy them. My name on America Online is JohnKing1
********
NThe first macro below will look for the file "To Do" on the desktop. If it is L
Jthere, it will arrange the records by the numbers in the left column. If N
Lnot, it will look on the current data disk for the "To Do" data base file. F
If it is not on the disk, a message will appear and the macro stops.
NUse the "To Do" data base file to keep track of chores or things to do. When I
Gthe item is completed type in the date or some other item in the "Date P
NCompleted" field and the record will disappear from view. Give each record a N
Lpriority number in the left column. Each time you want to re-sort the list M
Kpress ba-e and presto...the list is renumbered and rearranged. I use it a M
Klot! Change the review/add/change screen as you like, but always keep the 5
numbered column on the far left side of the screen.
start
C<ba-e>:<all : oa-q : $0="To Do" : find : if Z=0 then {& "path" : & M
K"/YourDisk/SubDir/etc" } : sa-A : find : if Z=0 then : msg ' Sorry, Cannot M
Kfind the Data Base File ' : endmacro else rtn : else rtn : elseoff : msg ' N
LWait, Please... ' : display 0 : insert:zoom:oa-, : oa-1: oa-a : rtn>3<rtn : P
Nx= peekword $3917:a=1: begin : oa-Y : print A:print ". ":down:A=A+1:x=x-1: if
x>0 rpt else ba-ctrl-E>!
NNOTE: Change the pathname to where you keep your "To Do" file then remove the
{ } brackets if you wish.
N<ba-ctrl-E>:<asr : display 1 : oa-1 : msg ' List Arranged and Renumbered ' : 5
stop>! QUICKLY Retrieves To Do Data base from Disk.
--------------------------------------------------------------------------
LTHE FOLLOWING ARE MISCELLANEOUS MACROS THAT I FIND HANDY, BUT HAVE NOT SEEN
ELSEWHERE.
--------------------------------------------------------------------------
NR:<adb><display 0 : oa-L : rtn esc>2<rtn : display 1 : msg ' Cursor NOW MOVES N
LTO THE RIGHT! ' : Ba-Ctrl-D : msg " " : >! Change cursor to right movement
in Data Base.
ND:<adb><display 0 : oa-L : rtn esc>1<rtn : display 1 : msg ' Cursor NOW MOVES N
LDOWN! ' : Ba-Ctrl-D : msg " " : >! Change cursor to right movement in Data
Base.
L:<adb><zoom><oa-9><oa-z><oa-Down>y<oa-Down><oa-Down><oa-Down><oa-Down>J
<oa-Down><oa-Down><oa-Down><oa-Down><oa-Down><oa-Down><oa-z><Down><Down>N
<Down><Down><Down><Down><Down><Down><Down><Down><Up><Up><Up><Up><Up><Up><Up>9
<Up><Up>! Adds 10 empty records to bottom of data base.
MX:<all: onerr stop : begin : cell : $1=$0 : down : cell : $2=$0 : if $1=$2 : N
Lrpt>! Runs the cursor through vertical columns in a spreadsheet, data base, O
Mor word processor. The cursor will stop with every DIFFERENT FIELD from the K
one above it. Very handy with large lists like classical composers, etc.
LThe macro below (ba-N) looks through a column of numbers in a data base, if H
Fnumbers are repeated, it goes on, but if a number is missing from the -
numerical sequence it stops with a message.
L<ba-N>:<adb: onerr stop : msg " " : cell : $1=$0 : down : cell : $2=$0 : if P
N$1=$2 then rpt else : A = val $1 : B=A+1 : if B=val $2 then down : rpt : else P
Nbell: bell : C=A+1 : $9 = "You are missing number " + str$ C + " here" : msg C
$9 : stop>! Looks for missing numbers in series. Saves eyeballs.
L<ba-b>:<all><oa-Q esc>5<rtn>3<rtn disk : sa-0>/<msg ' Type Directory Name ' /
:>! Create a subdirectory in Current Prefix.
K<ba-s>:<all oa-q : esc : print "4" : rtn : oa-right : rtn : stop>! Removes P
NAll unchanged or saved files from the desktop; prompts user to save or remove F
others. This macro is for cleaning the desktop. I use it every day.
I<ba-X>:<all: onerr stop : begin : msg " " : cell : $1=$0 : down : cell : N
L$2=$0 : if $1=$2 then : msg ' You have a duplication here ' : stop : else : M
Krpt>! Looks through a vertical list of anything and tell you if you have a %
duplication; another eyeball saver.
NThe following set of macros will copy all the fields in selected records from 5
a data base to another having identical categories.
N<ba-T>:<All : oa-Q : msg ' Select Source Data Base File ' : Ba-Ctrl-D : rtn : C
ba-ctrl-T : msg ' Select Records To Transfer, then Press SA-* '>!
D<ba-ctrl-T>:<asr: display 0 : oa-P>2<rtn>2<rtn>RAC<rtn : esc >2<rtn J
rtn>XXXX<rtn esc esc oa-L>2<display 1 : rtn : $0="XXXX" : find rtn rtn>!
H*:<all : display 0 : oa-1 : oa-C>T<oa-9: rtn : ba-ctrl-X : oa-q : msg ' P
NSelect Destination Data Base File ' : Ba-Ctrl-D : rtn : ba-ctrl-T : display 0 B
: oa-C : Print "F" : ba-ctrl-X : msg ' Operation Complete ' :>!
L<ba-Ctrl-X>:<adb: oa-q : rtn : oa-L>2<display 1 : rtn $0="RAC" : find : rtn J
rtn : oa-P >5< rtn : find : rtn>Y5< rtn : $0="XXXX" : find : rtn>Y<esc>!
--------------------------------------------------------------------------
MTHE MACROS BELOW ARE COMMON ONES THAT I INCLUDE ON ALL MACRO SETS AS PART OF
A TEMPLATE.
--------------------------------------------------------------------------
Cursor-positioning macros
<left>:<adb><onerr stop><oa-tab><tab>!
<left>:<all : first>! Jump to beginning of line
<right>:<adb><a=0><begin><right><A=A+1><ifnot A=80><rpt>!
<right>:<all: last>! Jump to end of line
<up>:<all><sa-left><oa-up>! Home to top left of screen
<down>:<all><sa-left><oa-down>! Home to bottom left of screen
LA:<all><oa-Q : display 0 : esc rtn display 1 : rtn>! add files to Desktop
from anywhere in AW
EThe following compiles current file; add a <rtn> token after "NB" to O
Mautomatically execute the first macro in the new set; the N and B at the end K
Iselect the "No pause" and compile from "Beginning" options in the "Macro
Compiler" TimeOut application
F<ba-c>:<awp : oa-esc : $0="Macro Compiler" : find : rtn rtn rtn rtn>!
Compiles current macro file
K<ba-ctrl-D>:<asr : keyto 13 : if Z=0 then : msg ' Macro Aborted ' : stop : C
else>! Substitute for INPUT; allows user to escape out of macro.
<ba-L>:<All: launch "Ultra.System">!